﻿declare @brand as varchar(100) = 'Aveda'

delete Warehouse.dbo.productname
from Warehouse.dbo.productname n
	inner join Warehouse.dbo.Brand b on n.BrandId = b.id
where b.Name = @brand